Overview: Horizontal Merge

Use this operation to combine two datasets side by side.

Select fields from both datasets to be included in the new dataset. Choose which rows from each dataset to align. These are the row numbers at which the datasets will merge. There is also an option to only merge rows where both datasets have values at the same row number. This eliminates rows which only contain data from one dataset.

This operation is not dependant on the timestamp field in any way. These timestamp fields are treated as any other field, and will be listed next to each other in the new dataset. The timestamp fields will not influence the order of the values of the other fields in any way.

Properties

Category:	Combine
Performance risk:	Low performance risk
Knowledge required:	None

Effect on datasets

How many datasets are required to perform this operation?	Two
Does it create a new dataset?	Yes
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	Yes
Does it modify the current dataset in any way?	No

Requirements

This operation needs two datasets to merge.
All fields and all field types from both datasets can be selected.

Results

A single merged dataset is created, containing all the selected fields from both datasets.
This new dataset might have fewer or more rows than the sum of the rows of the component datasets, depending on the configuration options selected.
If the alignment of the rows when merging the datasets are offset, or if the two component datasets are different sizes, some of the merged rows might not contain values for certain fields, in which case ‘null’ values will be inserted.